77d788681014d43b56e075d2ee21501aa8589eab,zanata-war/src/main/java/org/zanata/dao/TextFlowDAO.java,TextFlowDAO,getTextFlowByDocumentIdWithConstraint,#DocumentId#HLocale#FilterConstraints#number#number#,371
Before Change
if (hasSearch)
{
queryBuilder.append(" and (").append(buildSearchConditionForHQL(constraints.getSearchString(), "tf")); // search in source
// search in target
queryBuilder.append(" or exists (")
.append("from HTextFlowTarget where textFlow = tf and locale = :locale")
.append(" and ").append(buildSearchConditionForHQL(constraints.getSearchString(), ""))
.append(")");
// end search in target
queryBuilder.append(")"); // end search
}
if (!includeAllState)
{
// content state restriction
queryBuilder.append(" and (exists (from HTextFlowTarget where textFlow = tf and locale = :locale and state in (:contentStateList))");
if (constraints.isIncludeNew())
{
queryBuilder.append(" or (:locale not in indices(tf.targets)"); // null target
if (hasSearch)
{
queryBuilder.append(" and ").append(buildSearchConditionForHQL(constraints.getSearchString(), "tf"));
}
queryBuilder.append(")"); // end null target condition
}
After Change
}
if (hasSearch)
{
textFlowQuery.setParameter(searchStringNamedParam, "%" + constraints.getSearchString().toLowerCase() + "%");
}
textFlowQuery.setFirstResult(firstResult).setMaxResults(maxResult);
textFlowQuery.setCacheable(true).setComment("TextFlowDAO.getTextFlowByDocumentIdWithConstraint");